if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_ShoppingCart') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_ShoppingCart
END
GO
	create View V_ShoppingCart
	as
	select  [guid],MemLoginID,ProductGuid,OriginalImge,NAME,RepertoryNumber,
			Attributes,ExtensionAttriutes,BuyNumber,MarketPrice,BuyPrice,IsJoinActivity,IsPresent,CreateTime 
	from dbo.ShopNum1_Cart